Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 9800 |
| Missing cells | 11 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.6 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 6 |
| DateTime | 2 |
| Categorical | 7 |
Reproduction
| Analysis started | 2024-01-19 02:52:26.567603 |
|---|---|
| Analysis finished | 2024-01-19 02:52:35.576568 |
| Duration | 9.01 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
Row ID
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 9800 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4900.5 |
| Minimum | 1 |
|---|---|
| Maximum | 9800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 490.95 |
| Q1 | 2450.75 |
| median | 4900.5 |
| Q3 | 7350.25 |
| 95-th percentile | 9310.05 |
| Maximum | 9800 |
| Range | 9799 |
| Interquartile range (IQR) | 4899.5 |
Descriptive statistics
| Standard deviation | 2829.1607 |
|---|---|
| Coefficient of variation (CV) | 0.57732081 |
| Kurtosis | -1.2 |
| Mean | 4900.5 |
| Median Absolute Deviation (MAD) | 2450 |
| Skewness | 0 |
| Sum | 48024900 |
| Variance | 8004150 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 6537 | 1 | < 0.1% |
| 6530 | 1 | < 0.1% |
| 6531 | 1 | < 0.1% |
| 6532 | 1 | < 0.1% |
| 6533 | 1 | < 0.1% |
| 6534 | 1 | < 0.1% |
| 6535 | 1 | < 0.1% |
| 6536 | 1 | < 0.1% |
| 6538 | 1 | < 0.1% |
| Other values (9790) | 9790 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 9800 | 1 | |
| 9799 | 1 | |
| 9798 | 1 | |
| 9797 | 1 | |
| 9796 | 1 | |
| 9795 | 1 | |
| 9794 | 1 | |
| 9793 | 1 | |
| 9792 | 1 | |
| 9791 | 1 |
Order ID
Text
| Distinct | 4922 |
|---|---|
| Distinct (%) | 50.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Characters and Unicode
| Total characters | 137200 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2499 ? |
|---|---|
| Unique (%) | 25.5% |
Sample
| 1st row | CA-2017-152156 |
|---|---|
| 2nd row | CA-2017-152156 |
| 3rd row | CA-2017-138688 |
| 4th row | US-2016-108966 |
| 5th row | US-2016-108966 |
| Value | Count | Frequency (%) |
| ca-2018-100111 | 14 | 0.1% |
| ca-2018-157987 | 12 | 0.1% |
| ca-2017-165330 | 11 | 0.1% |
| us-2017-108504 | 11 | 0.1% |
| ca-2017-105732 | 10 | 0.1% |
| ca-2016-131338 | 10 | 0.1% |
| us-2016-126977 | 10 | 0.1% |
| ca-2016-158421 | 9 | 0.1% |
| ca-2016-132626 | 9 | 0.1% |
| ca-2017-145177 | 9 | 0.1% |
| Other values (4912) | 9695 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 25023 | |
| - | 19600 | |
| 0 | 15209 | |
| 2 | 15047 | |
| C | 8161 | 5.9% |
| A | 8161 | 5.9% |
| 6 | 7282 | 5.3% |
| 8 | 7234 | 5.3% |
| 5 | 7084 | 5.2% |
| 7 | 6568 | 4.8% |
| Other values (5) | 17831 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 98000 | |
| Dash Punctuation | 19600 | 14.3% |
| Uppercase Letter | 19600 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 25023 | |
| 0 | 15209 | |
| 2 | 15047 | |
| 6 | 7282 | 7.4% |
| 8 | 7234 | 7.4% |
| 5 | 7084 | 7.2% |
| 7 | 6568 | 6.7% |
| 3 | 5352 | 5.5% |
| 4 | 5300 | 5.4% |
| 9 | 3901 | 4.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8161 | |
| A | 8161 | |
| U | 1639 | 8.4% |
| S | 1639 | 8.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 117600 | |
| Latin | 19600 | 14.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 25023 | |
| - | 19600 | |
| 0 | 15209 | |
| 2 | 15047 | |
| 6 | 7282 | 6.2% |
| 8 | 7234 | 6.2% |
| 5 | 7084 | 6.0% |
| 7 | 6568 | 5.6% |
| 3 | 5352 | 4.6% |
| 4 | 5300 | 4.5% |
Latin
| Value | Count | Frequency (%) |
| C | 8161 | |
| A | 8161 | |
| U | 1639 | 8.4% |
| S | 1639 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 137200 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 25023 | |
| - | 19600 | |
| 0 | 15209 | |
| 2 | 15047 | |
| C | 8161 | 5.9% |
| A | 8161 | 5.9% |
| 6 | 7282 | 5.3% |
| 8 | 7234 | 5.3% |
| 5 | 7084 | 5.2% |
| 7 | 6568 | 4.8% |
| Other values (5) | 17831 |
Order Date
Date
| Distinct | 1230 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Minimum | 2015-01-02 00:00:00 |
|---|---|
| Maximum | 2018-12-30 00:00:00 |
Histogram with fixed size bins (bins=50)
Ship Date
Date
| Distinct | 1326 |
|---|---|
| Distinct (%) | 13.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Minimum | 2015-01-04 00:00:00 |
|---|---|
| Maximum | 2019-05-01 00:00:00 |
Histogram with fixed size bins (bins=50)
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 538 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.822959 |
| Min length | 8 |
Characters and Unicode
| Total characters | 125665 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 5859 | |
| Second Class | 1902 | 19.4% |
| First Class | 1501 | 15.3% |
| Same Day | 538 | 5.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 9262 | |
| standard | 5859 | |
| second | 1902 | 9.7% |
| first | 1501 | 7.7% |
| same | 538 | 2.7% |
| day | 538 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 22056 | |
| s | 20025 | |
| d | 13620 | |
| 9800 | ||
| l | 9262 | |
| C | 9262 | |
| S | 8299 | 6.6% |
| n | 7761 | 6.2% |
| r | 7360 | 5.9% |
| t | 7360 | 5.9% |
| Other values (8) | 10860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 96265 | |
| Uppercase Letter | 19600 | 15.6% |
| Space Separator | 9800 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 22056 | |
| s | 20025 | |
| d | 13620 | |
| l | 9262 | |
| n | 7761 | 8.1% |
| r | 7360 | 7.6% |
| t | 7360 | 7.6% |
| e | 2440 | 2.5% |
| c | 1902 | 2.0% |
| o | 1902 | 2.0% |
| Other values (3) | 2577 | 2.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 9262 | |
| S | 8299 | |
| F | 1501 | 7.7% |
| D | 538 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 9800 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 115865 | |
| Common | 9800 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 22056 | |
| s | 20025 | |
| d | 13620 | |
| l | 9262 | |
| C | 9262 | |
| S | 8299 | 7.2% |
| n | 7761 | 6.7% |
| r | 7360 | 6.4% |
| t | 7360 | 6.4% |
| e | 2440 | 2.1% |
| Other values (7) | 8420 | 7.3% |
Common
| Value | Count | Frequency (%) |
| 9800 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 125665 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 22056 | |
| s | 20025 | |
| d | 13620 | |
| 9800 | ||
| l | 9262 | |
| C | 9262 | |
| S | 8299 | 6.6% |
| n | 7761 | 6.2% |
| r | 7360 | 5.9% |
| t | 7360 | 5.9% |
| Other values (8) | 10860 |
Customer ID
Text
| Distinct | 793 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 78400 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | CG-12520 |
|---|---|
| 2nd row | CG-12520 |
| 3rd row | DV-13045 |
| 4th row | SO-20335 |
| 5th row | SO-20335 |
| Value | Count | Frequency (%) |
| wb-21850 | 35 | 0.4% |
| pp-18955 | 34 | 0.3% |
| ma-17560 | 34 | 0.3% |
| jl-15835 | 33 | 0.3% |
| ck-12205 | 32 | 0.3% |
| jd-15895 | 32 | 0.3% |
| sv-20365 | 32 | 0.3% |
| ep-13915 | 31 | 0.3% |
| zc-21910 | 31 | 0.3% |
| ap-10915 | 31 | 0.3% |
| Other values (783) | 9475 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 11696 | |
| - | 9800 | |
| 0 | 8365 | 10.7% |
| 5 | 7709 | 9.8% |
| 2 | 4607 | 5.9% |
| 7 | 2863 | 3.7% |
| 6 | 2845 | 3.6% |
| 9 | 2836 | 3.6% |
| 8 | 2777 | 3.5% |
| 3 | 2738 | 3.5% |
| Other values (30) | 22164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 49000 | |
| Uppercase Letter | 19557 | 24.9% |
| Dash Punctuation | 9800 | 12.5% |
| Lowercase Letter | 43 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1773 | 9.1% |
| C | 1701 | 8.7% |
| M | 1687 | 8.6% |
| B | 1613 | 8.2% |
| D | 1258 | 6.4% |
| A | 1196 | 6.1% |
| J | 1120 | 5.7% |
| P | 1082 | 5.5% |
| H | 927 | 4.7% |
| K | 912 | 4.7% |
| Other values (16) | 6288 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 11696 | |
| 0 | 8365 | |
| 5 | 7709 | |
| 2 | 4607 | 9.4% |
| 7 | 2863 | 5.8% |
| 6 | 2845 | 5.8% |
| 9 | 2836 | 5.8% |
| 8 | 2777 | 5.7% |
| 3 | 2738 | 5.6% |
| 4 | 2564 | 5.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 29 | |
| o | 8 | 18.6% |
| l | 6 | 14.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9800 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 58800 | |
| Latin | 19600 | 25.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1773 | 9.0% |
| C | 1701 | 8.7% |
| M | 1687 | 8.6% |
| B | 1613 | 8.2% |
| D | 1258 | 6.4% |
| A | 1196 | 6.1% |
| J | 1120 | 5.7% |
| P | 1082 | 5.5% |
| H | 927 | 4.7% |
| K | 912 | 4.7% |
| Other values (19) | 6331 |
Common
| Value | Count | Frequency (%) |
| 1 | 11696 | |
| - | 9800 | |
| 0 | 8365 | |
| 5 | 7709 | |
| 2 | 4607 | 7.8% |
| 7 | 2863 | 4.9% |
| 6 | 2845 | 4.8% |
| 9 | 2836 | 4.8% |
| 8 | 2777 | 4.7% |
| 3 | 2738 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 78400 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 11696 | |
| - | 9800 | |
| 0 | 8365 | 10.7% |
| 5 | 7709 | 9.8% |
| 2 | 4607 | 5.9% |
| 7 | 2863 | 3.7% |
| 6 | 2845 | 3.6% |
| 9 | 2836 | 3.6% |
| 8 | 2777 | 3.5% |
| 3 | 2738 | 3.5% |
| Other values (30) | 22164 |
Customer Name
Text
| Distinct | 793 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.962959 |
| Min length | 7 |
Characters and Unicode
| Total characters | 127037 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Claire Gute |
|---|---|
| 2nd row | Claire Gute |
| 3rd row | Darrin Van Huff |
| 4th row | Sean O'Donnell |
| 5th row | Sean O'Donnell |
| Value | Count | Frequency (%) |
| michael | 119 | 0.6% |
| frank | 112 | 0.6% |
| john | 106 | 0.5% |
| patrick | 96 | 0.5% |
| stewart | 93 | 0.5% |
| paul | 92 | 0.5% |
| rick | 91 | 0.5% |
| brian | 88 | 0.4% |
| matt | 86 | 0.4% |
| ken | 85 | 0.4% |
| Other values (901) | 18697 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 11750 | 9.2% |
| e | 11605 | 9.1% |
| n | 10005 | 7.9% |
| 9865 | 7.8% | |
| r | 9318 | 7.3% |
| i | 7797 | 6.1% |
| l | 6389 | 5.0% |
| o | 5722 | 4.5% |
| t | 5376 | 4.2% |
| s | 4454 | 3.5% |
| Other values (47) | 44756 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 96951 | |
| Uppercase Letter | 20068 | 15.8% |
| Space Separator | 9865 | 7.8% |
| Other Punctuation | 124 | 0.1% |
| Dash Punctuation | 29 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 11750 | |
| e | 11605 | |
| n | 10005 | |
| r | 9318 | |
| i | 7797 | 8.0% |
| l | 6389 | 6.6% |
| o | 5722 | 5.9% |
| t | 5376 | 5.5% |
| s | 4454 | 4.6% |
| h | 3787 | 3.9% |
| Other values (18) | 20748 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1806 | 9.0% |
| S | 1773 | 8.8% |
| M | 1724 | 8.6% |
| B | 1667 | 8.3% |
| D | 1287 | 6.4% |
| A | 1251 | 6.2% |
| J | 1120 | 5.6% |
| P | 1082 | 5.4% |
| H | 964 | 4.8% |
| K | 944 | 4.7% |
| Other values (16) | 6450 |
Space Separator
| Value | Count | Frequency (%) |
| 9865 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 124 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 117019 | |
| Common | 10018 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 11750 | 10.0% |
| e | 11605 | 9.9% |
| n | 10005 | 8.5% |
| r | 9318 | 8.0% |
| i | 7797 | 6.7% |
| l | 6389 | 5.5% |
| o | 5722 | 4.9% |
| t | 5376 | 4.6% |
| s | 4454 | 3.8% |
| h | 3787 | 3.2% |
| Other values (44) | 40816 |
Common
| Value | Count | Frequency (%) |
| 9865 | ||
| ' | 124 | 1.2% |
| - | 29 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 126949 | |
| None | 88 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 11750 | 9.3% |
| e | 11605 | 9.1% |
| n | 10005 | 7.9% |
| 9865 | 7.8% | |
| r | 9318 | 7.3% |
| i | 7797 | 6.1% |
| l | 6389 | 5.0% |
| o | 5722 | 4.5% |
| t | 5376 | 4.2% |
| s | 4454 | 3.5% |
| Other values (44) | 44668 |
None
| Value | Count | Frequency (%) |
| ö | 60 | |
| ä | 23 | 26.1% |
| ü | 5 | 5.7% |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8358163 |
| Min length | 8 |
Characters and Unicode
| Total characters | 86591 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5101 | |
| Corporate | 2953 | |
| Home Office | 1746 | 17.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5101 | |
| corporate | 2953 | |
| home | 1746 | 15.1% |
| office | 1746 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 12753 | |
| e | 11546 | |
| r | 11007 | |
| C | 8054 | |
| m | 6847 | |
| n | 5101 | 5.9% |
| s | 5101 | 5.9% |
| u | 5101 | 5.9% |
| f | 3492 | 4.0% |
| t | 2953 | 3.4% |
| Other values (7) | 14636 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 73299 | |
| Uppercase Letter | 11546 | 13.3% |
| Space Separator | 1746 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 12753 | |
| e | 11546 | |
| r | 11007 | |
| m | 6847 | |
| n | 5101 | 7.0% |
| s | 5101 | 7.0% |
| u | 5101 | 7.0% |
| f | 3492 | 4.8% |
| t | 2953 | 4.0% |
| p | 2953 | 4.0% |
| Other values (3) | 6445 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8054 | |
| H | 1746 | 15.1% |
| O | 1746 | 15.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1746 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 84845 | |
| Common | 1746 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 12753 | |
| e | 11546 | |
| r | 11007 | |
| C | 8054 | |
| m | 6847 | |
| n | 5101 | 6.0% |
| s | 5101 | 6.0% |
| u | 5101 | 6.0% |
| f | 3492 | 4.1% |
| t | 2953 | 3.5% |
| Other values (6) | 12890 |
Common
| Value | Count | Frequency (%) |
| 1746 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86591 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 12753 | |
| e | 11546 | |
| r | 11007 | |
| C | 8054 | |
| m | 6847 | |
| n | 5101 | 5.9% |
| s | 5101 | 5.9% |
| u | 5101 | 5.9% |
| f | 3492 | 4.0% |
| t | 2953 | 3.4% |
| Other values (7) | 14636 |
Country
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 127400 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 9800 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 9800 | |
| states | 9800 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 29400 | |
| e | 19600 | |
| U | 9800 | 7.7% |
| n | 9800 | 7.7% |
| i | 9800 | 7.7% |
| d | 9800 | 7.7% |
| 9800 | 7.7% | |
| S | 9800 | 7.7% |
| a | 9800 | 7.7% |
| s | 9800 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98000 | |
| Uppercase Letter | 19600 | 15.4% |
| Space Separator | 9800 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 29400 | |
| e | 19600 | |
| n | 9800 | 10.0% |
| i | 9800 | 10.0% |
| d | 9800 | 10.0% |
| a | 9800 | 10.0% |
| s | 9800 | 10.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 9800 | |
| S | 9800 |
Space Separator
| Value | Count | Frequency (%) |
| 9800 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 117600 | |
| Common | 9800 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 29400 | |
| e | 19600 | |
| U | 9800 | 8.3% |
| n | 9800 | 8.3% |
| i | 9800 | 8.3% |
| d | 9800 | 8.3% |
| S | 9800 | 8.3% |
| a | 9800 | 8.3% |
| s | 9800 | 8.3% |
Common
| Value | Count | Frequency (%) |
| 9800 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127400 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 29400 | |
| e | 19600 | |
| U | 9800 | 7.7% |
| n | 9800 | 7.7% |
| i | 9800 | 7.7% |
| d | 9800 | 7.7% |
| 9800 | 7.7% | |
| S | 9800 | 7.7% |
| a | 9800 | 7.7% |
| s | 9800 | 7.7% |
City
Text
| Distinct | 529 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 9.3178571 |
| Min length | 4 |
Characters and Unicode
| Total characters | 91315 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 71 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Los Angeles |
| 4th row | Fort Lauderdale |
| 5th row | Fort Lauderdale |
| Value | Count | Frequency (%) |
| city | 970 | 7.0% |
| new | 910 | 6.5% |
| york | 896 | 6.4% |
| san | 792 | 5.7% |
| los | 728 | 5.2% |
| angeles | 728 | 5.2% |
| philadelphia | 532 | 3.8% |
| francisco | 500 | 3.6% |
| seattle | 426 | 3.1% |
| houston | 374 | 2.7% |
| Other values (553) | 7071 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8540 | 9.4% |
| a | 7422 | 8.1% |
| o | 7363 | 8.1% |
| i | 6101 | 6.7% |
| n | 6063 | 6.6% |
| l | 5896 | 6.5% |
| s | 4608 | 5.0% |
| r | 4365 | 4.8% |
| t | 4357 | 4.8% |
| 4127 | 4.5% | |
| Other values (41) | 32473 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 73261 | |
| Uppercase Letter | 13927 | 15.3% |
| Space Separator | 4127 | 4.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8540 | |
| a | 7422 | |
| o | 7363 | |
| i | 6101 | 8.3% |
| n | 6063 | 8.3% |
| l | 5896 | 8.0% |
| s | 4608 | 6.3% |
| r | 4365 | 6.0% |
| t | 4357 | 5.9% |
| c | 2339 | 3.2% |
| Other values (16) | 16207 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2042 | |
| S | 1712 | |
| L | 1255 | |
| A | 1212 | |
| N | 1103 | |
| P | 993 | 7.1% |
| Y | 916 | 6.6% |
| F | 777 | 5.6% |
| D | 623 | 4.5% |
| H | 614 | 4.4% |
| Other values (14) | 2680 |
Space Separator
| Value | Count | Frequency (%) |
| 4127 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 87188 | |
| Common | 4127 | 4.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8540 | 9.8% |
| a | 7422 | 8.5% |
| o | 7363 | 8.4% |
| i | 6101 | 7.0% |
| n | 6063 | 7.0% |
| l | 5896 | 6.8% |
| s | 4608 | 5.3% |
| r | 4365 | 5.0% |
| t | 4357 | 5.0% |
| c | 2339 | 2.7% |
| Other values (40) | 30134 |
Common
| Value | Count | Frequency (%) |
| 4127 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 91315 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8540 | 9.4% |
| a | 7422 | 8.1% |
| o | 7363 | 8.1% |
| i | 6101 | 6.7% |
| n | 6063 | 6.6% |
| l | 5896 | 6.5% |
| s | 4608 | 5.0% |
| r | 4365 | 4.8% |
| t | 4357 | 4.8% |
| 4127 | 4.5% | |
| Other values (41) | 32473 |
State
Categorical
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Washington | |
| Other values (44) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4943878 |
| Min length | 4 |
Characters and Unicode
| Total characters | 83245 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 1946 | |
| New York | 1097 | 11.2% |
| Texas | 973 | 9.9% |
| Pennsylvania | 582 | 5.9% |
| Washington | 504 | 5.1% |
| Illinois | 483 | 4.9% |
| Ohio | 454 | 4.6% |
| Florida | 373 | 3.8% |
| Michigan | 253 | 2.6% |
| North Carolina | 247 | 2.5% |
| Other values (39) | 2888 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| california | 1946 | |
| new | 1283 | 11.2% |
| york | 1097 | 9.6% |
| texas | 973 | 8.5% |
| pennsylvania | 582 | 5.1% |
| washington | 504 | 4.4% |
| illinois | 483 | 4.2% |
| ohio | 454 | 4.0% |
| florida | 373 | 3.3% |
| carolina | 289 | 2.5% |
| Other values (43) | 3486 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10556 | |
| i | 9695 | |
| n | 7958 | 9.6% |
| o | 7167 | 8.6% |
| r | 5420 | 6.5% |
| e | 4961 | 6.0% |
| l | 4725 | 5.7% |
| s | 4556 | 5.5% |
| C | 2506 | 3.0% |
| f | 1956 | 2.3% |
| Other values (36) | 23745 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 70115 | |
| Uppercase Letter | 11460 | 13.8% |
| Space Separator | 1670 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 10556 | |
| i | 9695 | |
| n | 7958 | |
| o | 7167 | |
| r | 5420 | |
| e | 4961 | |
| l | 4725 | |
| s | 4556 | |
| f | 1956 | 2.8% |
| h | 1876 | 2.7% |
| Other values (14) | 11245 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2506 | |
| N | 1614 | |
| T | 1156 | |
| Y | 1097 | |
| M | 761 | 6.6% |
| I | 720 | 6.3% |
| O | 642 | 5.6% |
| W | 614 | 5.4% |
| P | 582 | 5.1% |
| F | 373 | 3.3% |
| Other values (11) | 1395 |
Space Separator
| Value | Count | Frequency (%) |
| 1670 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 81575 | |
| Common | 1670 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 10556 | |
| i | 9695 | |
| n | 7958 | 9.8% |
| o | 7167 | 8.8% |
| r | 5420 | 6.6% |
| e | 4961 | 6.1% |
| l | 4725 | 5.8% |
| s | 4556 | 5.6% |
| C | 2506 | 3.1% |
| f | 1956 | 2.4% |
| Other values (35) | 22075 |
Common
| Value | Count | Frequency (%) |
| 1670 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 83245 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 10556 | |
| i | 9695 | |
| n | 7958 | 9.6% |
| o | 7167 | 8.6% |
| r | 5420 | 6.5% |
| e | 4961 | 6.0% |
| l | 4725 | 5.7% |
| s | 4556 | 5.5% |
| C | 2506 | 3.0% |
| f | 1956 | 2.3% |
| Other values (36) | 23745 |
Postal Code
Real number (ℝ)
| Distinct | 626 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 11 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55273.322 |
| Minimum | 1040 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | 1040 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 23223 |
| median | 58103 |
| Q3 | 90008 |
| 95-th percentile | 98026 |
| Maximum | 99301 |
| Range | 98261 |
| Interquartile range (IQR) | 66785 |
Descriptive statistics
| Standard deviation | 32041.223 |
|---|---|
| Coefficient of variation (CV) | 0.57968695 |
| Kurtosis | -1.4926761 |
| Mean | 55273.322 |
| Median Absolute Deviation (MAD) | 31929 |
| Skewness | -0.13129452 |
| Sum | 5.4107055 × 108 |
| Variance | 1.02664 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10035 | 253 | 2.6% |
| 10024 | 225 | 2.3% |
| 10009 | 220 | 2.2% |
| 94122 | 195 | 2.0% |
| 10011 | 193 | 2.0% |
| 94110 | 166 | 1.7% |
| 98105 | 165 | 1.7% |
| 19134 | 160 | 1.6% |
| 90049 | 150 | 1.5% |
| 98103 | 149 | 1.5% |
| Other values (616) | 7913 |
| Value | Count | Frequency (%) |
| 1040 | 1 | < 0.1% |
| 1453 | 6 | 0.1% |
| 1752 | 2 | < 0.1% |
| 1810 | 4 | < 0.1% |
| 1841 | 33 | |
| 1852 | 16 | |
| 1915 | 3 | < 0.1% |
| 2038 | 17 | |
| 2138 | 6 | 0.1% |
| 2148 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 6 | 0.1% |
| 99207 | 7 | 0.1% |
| 98661 | 5 | 0.1% |
| 98632 | 3 | < 0.1% |
| 98502 | 5 | 0.1% |
| 98270 | 2 | < 0.1% |
| 98226 | 3 | < 0.1% |
| 98208 | 1 | < 0.1% |
| 98198 | 7 | 0.1% |
| 98115 | 112 |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.860102 |
| Min length | 4 |
Characters and Unicode
| Total characters | 47629 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 3140 | |
| East | 2785 | |
| Central | 2277 | |
| South | 1598 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3140 | |
| east | 2785 | |
| central | 2277 | |
| south | 1598 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9800 | |
| s | 5925 | |
| e | 5417 | |
| a | 5062 | |
| W | 3140 | 6.6% |
| E | 2785 | 5.8% |
| C | 2277 | 4.8% |
| n | 2277 | 4.8% |
| r | 2277 | 4.8% |
| l | 2277 | 4.8% |
| Other values (4) | 6392 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 37829 | |
| Uppercase Letter | 9800 | 20.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 9800 | |
| s | 5925 | |
| e | 5417 | |
| a | 5062 | |
| n | 2277 | 6.0% |
| r | 2277 | 6.0% |
| l | 2277 | 6.0% |
| o | 1598 | 4.2% |
| u | 1598 | 4.2% |
| h | 1598 | 4.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 3140 | |
| E | 2785 | |
| C | 2277 | |
| S | 1598 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 47629 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 9800 | |
| s | 5925 | |
| e | 5417 | |
| a | 5062 | |
| W | 3140 | 6.6% |
| E | 2785 | 5.8% |
| C | 2277 | 4.8% |
| n | 2277 | 4.8% |
| r | 2277 | 4.8% |
| l | 2277 | 4.8% |
| Other values (4) | 6392 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47629 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 9800 | |
| s | 5925 | |
| e | 5417 | |
| a | 5062 | |
| W | 3140 | 6.6% |
| E | 2785 | 5.8% |
| C | 2277 | 4.8% |
| n | 2277 | 4.8% |
| r | 2277 | 4.8% |
| l | 2277 | 4.8% |
| Other values (4) | 6392 |
Product ID
Text
| Distinct | 1861 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 147000 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 95 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | FUR-BO-10001798 |
|---|---|
| 2nd row | FUR-CH-10000454 |
| 3rd row | OFF-LA-10000240 |
| 4th row | FUR-TA-10000577 |
| 5th row | OFF-ST-10000760 |
| Value | Count | Frequency (%) |
| off-pa-10001970 | 19 | 0.2% |
| tec-ac-10003832 | 18 | 0.2% |
| fur-fu-10004270 | 16 | 0.2% |
| tec-ac-10002049 | 15 | 0.2% |
| tec-ac-10003628 | 15 | 0.2% |
| fur-ch-10002647 | 15 | 0.2% |
| fur-fu-10001473 | 14 | 0.1% |
| off-pa-10002377 | 14 | 0.1% |
| off-bi-10001524 | 14 | 0.1% |
| fur-ch-10001146 | 14 | 0.1% |
| Other values (1851) | 9646 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34375 | |
| - | 19600 | |
| F | 15041 | |
| 1 | 14705 | |
| O | 6201 | 4.2% |
| 2 | 4773 | 3.2% |
| 4 | 4737 | 3.2% |
| 3 | 4721 | 3.2% |
| A | 4338 | 3.0% |
| 5 | 3340 | 2.3% |
| Other values (17) | 35169 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 78400 | |
| Uppercase Letter | 49000 | |
| Dash Punctuation | 19600 | 13.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 15041 | |
| O | 6201 | |
| A | 4338 | 8.9% |
| C | 3242 | 6.6% |
| U | 3193 | 6.5% |
| T | 2959 | 6.0% |
| R | 2863 | 5.8% |
| P | 2673 | 5.5% |
| E | 2061 | 4.2% |
| B | 1718 | 3.5% |
| Other values (6) | 4711 | 9.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 34375 | |
| 1 | 14705 | |
| 2 | 4773 | 6.1% |
| 4 | 4737 | 6.0% |
| 3 | 4721 | 6.0% |
| 5 | 3340 | 4.3% |
| 7 | 3032 | 3.9% |
| 9 | 3000 | 3.8% |
| 6 | 2924 | 3.7% |
| 8 | 2793 | 3.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 98000 | |
| Latin | 49000 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 15041 | |
| O | 6201 | |
| A | 4338 | 8.9% |
| C | 3242 | 6.6% |
| U | 3193 | 6.5% |
| T | 2959 | 6.0% |
| R | 2863 | 5.8% |
| P | 2673 | 5.5% |
| E | 2061 | 4.2% |
| B | 1718 | 3.5% |
| Other values (6) | 4711 | 9.6% |
Common
| Value | Count | Frequency (%) |
| 0 | 34375 | |
| - | 19600 | |
| 1 | 14705 | |
| 2 | 4773 | 4.9% |
| 4 | 4737 | 4.8% |
| 3 | 4721 | 4.8% |
| 5 | 3340 | 3.4% |
| 7 | 3032 | 3.1% |
| 9 | 3000 | 3.1% |
| 6 | 2924 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 147000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 34375 | |
| - | 19600 | |
| F | 15041 | |
| 1 | 14705 | |
| O | 6201 | 4.2% |
| 2 | 4773 | 3.2% |
| 4 | 4737 | 3.2% |
| 3 | 4721 | 3.2% |
| A | 4338 | 3.0% |
| 5 | 3340 | 2.3% |
| Other values (17) | 35169 |
Category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.802755 |
| Min length | 9 |
Characters and Unicode
| Total characters | 125467 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 5909 | |
| Furniture | 2078 | 21.2% |
| Technology | 1813 | 18.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 5909 | |
| supplies | 5909 | |
| furniture | 2078 | 13.2% |
| technology | 1813 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15709 | |
| i | 13896 | |
| p | 11818 | |
| f | 11818 | |
| u | 10065 | 8.0% |
| c | 7722 | 6.2% |
| l | 7722 | 6.2% |
| O | 5909 | 4.7% |
| s | 5909 | 4.7% |
| S | 5909 | 4.7% |
| Other values (10) | 28990 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 103849 | |
| Uppercase Letter | 15709 | 12.5% |
| Space Separator | 5909 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 15709 | |
| i | 13896 | |
| p | 11818 | |
| f | 11818 | |
| u | 10065 | |
| c | 7722 | |
| l | 7722 | |
| s | 5909 | 5.7% |
| r | 4156 | 4.0% |
| n | 3891 | 3.7% |
| Other values (5) | 11143 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 5909 | |
| S | 5909 | |
| F | 2078 | 13.2% |
| T | 1813 | 11.5% |
Space Separator
| Value | Count | Frequency (%) |
| 5909 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119558 | |
| Common | 5909 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 15709 | |
| i | 13896 | |
| p | 11818 | |
| f | 11818 | |
| u | 10065 | |
| c | 7722 | 6.5% |
| l | 7722 | 6.5% |
| O | 5909 | 4.9% |
| s | 5909 | 4.9% |
| S | 5909 | 4.9% |
| Other values (9) | 23081 |
Common
| Value | Count | Frequency (%) |
| 5909 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 125467 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 15709 | |
| i | 13896 | |
| p | 11818 | |
| f | 11818 | |
| u | 10065 | 8.0% |
| c | 7722 | 6.2% |
| l | 7722 | 6.2% |
| O | 5909 | 4.7% |
| s | 5909 | 4.7% |
| S | 5909 | 4.7% |
| Other values (10) | 28990 |
Sub-Category
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.1867347 |
| Min length | 3 |
Characters and Unicode
| Total characters | 70430 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1492 | |
| Paper | 1338 | |
| Furnishings | 931 | |
| Phones | 876 | |
| Storage | 832 | |
| Art | 785 | |
| Accessories | 756 | |
| Chairs | 607 | |
| Appliances | 459 | 4.7% |
| Labels | 357 | 3.6% |
| Other values (7) | 1367 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| binders | 1492 | |
| paper | 1338 | |
| furnishings | 931 | |
| phones | 876 | |
| storage | 832 | |
| art | 785 | |
| accessories | 756 | |
| chairs | 607 | |
| appliances | 459 | 4.7% |
| labels | 357 | 3.6% |
| Other values (7) | 1367 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 9728 | |
| e | 8695 | |
| r | 7021 | 10.0% |
| i | 5541 | 7.9% |
| n | 5266 | 7.5% |
| a | 4462 | 6.3% |
| o | 3230 | 4.6% |
| p | 2938 | 4.2% |
| h | 2529 | 3.6% |
| c | 2312 | 3.3% |
| Other values (18) | 18708 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 60630 | |
| Uppercase Letter | 9800 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 9728 | |
| e | 8695 | |
| r | 7021 | |
| i | 5541 | |
| n | 5266 | |
| a | 4462 | |
| o | 3230 | 5.3% |
| p | 2938 | 4.8% |
| h | 2529 | 4.2% |
| c | 2312 | 3.8% |
| Other values (8) | 8908 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2214 | |
| A | 2000 | |
| B | 1718 | |
| F | 1145 | |
| S | 1016 | |
| C | 673 | 6.9% |
| L | 357 | 3.6% |
| T | 314 | 3.2% |
| E | 248 | 2.5% |
| M | 115 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 70430 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 9728 | |
| e | 8695 | |
| r | 7021 | 10.0% |
| i | 5541 | 7.9% |
| n | 5266 | 7.5% |
| a | 4462 | 6.3% |
| o | 3230 | 4.6% |
| p | 2938 | 4.2% |
| h | 2529 | 3.6% |
| c | 2312 | 3.3% |
| Other values (18) | 18708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70430 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 9728 | |
| e | 8695 | |
| r | 7021 | 10.0% |
| i | 5541 | 7.9% |
| n | 5266 | 7.5% |
| a | 4462 | 6.3% |
| o | 3230 | 4.6% |
| p | 2938 | 4.2% |
| h | 2529 | 3.6% |
| c | 2312 | 3.3% |
| Other values (18) | 18708 |
Product Name
Text
| Distinct | 1849 |
|---|---|
| Distinct (%) | 18.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.7 KiB |
Length
| Max length | 127 |
|---|---|
| Median length | 78 |
| Mean length | 36.905714 |
| Min length | 5 |
Characters and Unicode
| Total characters | 361676 |
|---|---|
| Distinct characters | 85 |
| Distinct categories | 12 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 94 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | Bush Somerset Collection Bookcase |
|---|---|
| 2nd row | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back |
| 3rd row | Self-Adhesive Address Labels for Typewriters by Universal |
| 4th row | Bretford CR4500 Series Slim Rectangular Table |
| 5th row | Eldon Fold 'N Roll Cart System |
| Value | Count | Frequency (%) |
| xerox | 844 | 1.5% |
| x | 682 | 1.2% |
| with | 589 | 1.1% |
| 581 | 1.1% | |
| avery | 550 | 1.0% |
| for | 527 | 1.0% |
| binders | 512 | 0.9% |
| chair | 468 | 0.9% |
| black | 419 | 0.8% |
| phone | 368 | 0.7% |
| Other values (2797) | 49379 |
Most occurring characters
| Value | Count | Frequency (%) |
| 44744 | 12.4% | |
| e | 32886 | 9.1% |
| r | 20404 | 5.6% |
| o | 19493 | 5.4% |
| a | 18688 | 5.2% |
| i | 18301 | 5.1% |
| l | 16050 | 4.4% |
| n | 15291 | 4.2% |
| s | 14390 | 4.0% |
| t | 14283 | 3.9% |
| Other values (75) | 147146 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 233601 | |
| Uppercase Letter | 55190 | 15.3% |
| Space Separator | 45159 | 12.5% |
| Decimal Number | 17618 | 4.9% |
| Other Punctuation | 6992 | 1.9% |
| Dash Punctuation | 2872 | 0.8% |
| Final Punctuation | 67 | < 0.1% |
| Open Punctuation | 60 | < 0.1% |
| Close Punctuation | 60 | < 0.1% |
| Math Symbol | 33 | < 0.1% |
| Other values (2) | 24 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 32886 | |
| r | 20404 | 8.7% |
| o | 19493 | 8.3% |
| a | 18688 | 8.0% |
| i | 18301 | 7.8% |
| l | 16050 | 6.9% |
| n | 15291 | 6.5% |
| s | 14390 | 6.2% |
| t | 14283 | 6.1% |
| c | 8717 | 3.7% |
| Other values (18) | 55098 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6180 | 11.2% |
| C | 5896 | 10.7% |
| B | 5411 | 9.8% |
| P | 4823 | 8.7% |
| D | 2888 | 5.2% |
| A | 2885 | 5.2% |
| M | 2816 | 5.1% |
| T | 2566 | 4.6% |
| F | 2456 | 4.5% |
| L | 2233 | 4.0% |
| Other values (16) | 17036 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 3045 | |
| / | 1530 | |
| " | 1272 | |
| . | 457 | 6.5% |
| & | 277 | 4.0% |
| ' | 250 | 3.6% |
| # | 89 | 1.3% |
| % | 44 | 0.6% |
| ! | 9 | 0.1% |
| * | 8 | 0.1% |
| Other values (2) | 11 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3695 | |
| 0 | 2858 | |
| 2 | 2227 | |
| 4 | 1702 | |
| 3 | 1501 | |
| 5 | 1417 | 8.0% |
| 8 | 1227 | 7.0% |
| 9 | 1212 | 6.9% |
| 6 | 924 | 5.2% |
| 7 | 855 | 4.9% |
Space Separator
| Value | Count | Frequency (%) |
| 44744 | ||
| 415 | 0.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2872 |
Final Punctuation
| Value | Count | Frequency (%) |
| ” | 67 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 60 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 60 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 33 |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 19 |
Other Number
| Value | Count | Frequency (%) |
| ¾ | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 288791 | |
| Common | 72885 | 20.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 32886 | 11.4% |
| r | 20404 | 7.1% |
| o | 19493 | 6.7% |
| a | 18688 | 6.5% |
| i | 18301 | 6.3% |
| l | 16050 | 5.6% |
| n | 15291 | 5.3% |
| s | 14390 | 5.0% |
| t | 14283 | 4.9% |
| c | 8717 | 3.0% |
| Other values (44) | 110288 |
Common
| Value | Count | Frequency (%) |
| 44744 | ||
| 1 | 3695 | 5.1% |
| , | 3045 | 4.2% |
| - | 2872 | 3.9% |
| 0 | 2858 | 3.9% |
| 2 | 2227 | 3.1% |
| 4 | 1702 | 2.3% |
| / | 1530 | 2.1% |
| 3 | 1501 | 2.1% |
| 5 | 1417 | 1.9% |
| Other values (21) | 7294 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 361153 | |
| None | 437 | 0.1% |
| Punctuation | 86 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 44744 | 12.4% | |
| e | 32886 | 9.1% |
| r | 20404 | 5.6% |
| o | 19493 | 5.4% |
| a | 18688 | 5.2% |
| i | 18301 | 5.1% |
| l | 16050 | 4.4% |
| n | 15291 | 4.2% |
| s | 14390 | 4.0% |
| t | 14283 | 4.0% |
| Other values (69) | 146623 |
None
| Value | Count | Frequency (%) |
| 415 | ||
| é | 14 | 3.2% |
| ¾ | 5 | 1.1% |
| à | 3 | 0.7% |
Punctuation
| Value | Count | Frequency (%) |
| ” | 67 | |
| “ | 19 | 22.1% |
Sales
Real number (ℝ)
| Distinct | 5757 |
|---|---|
| Distinct (%) | 58.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 230.76906 |
| Minimum | 0.444 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 4.9598 |
| Q1 | 17.248 |
| median | 54.49 |
| Q3 | 210.605 |
| 95-th percentile | 959.984 |
| Maximum | 22638.48 |
| Range | 22638.036 |
| Interquartile range (IQR) | 193.357 |
Descriptive statistics
| Standard deviation | 626.65187 |
|---|---|
| Coefficient of variation (CV) | 2.7154935 |
| Kurtosis | 304.44509 |
| Mean | 230.76906 |
| Median Absolute Deviation (MAD) | 45.463 |
| Skewness | 12.983483 |
| Sum | 2261536.8 |
| Variance | 392692.57 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12.96 | 55 | 0.6% |
| 15.552 | 39 | 0.4% |
| 19.44 | 39 | 0.4% |
| 10.368 | 35 | 0.4% |
| 25.92 | 34 | 0.3% |
| 32.4 | 28 | 0.3% |
| 17.94 | 21 | 0.2% |
| 20.736 | 19 | 0.2% |
| 6.48 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (5747) | 9494 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | < 0.1% |
| 0.556 | 1 | < 0.1% |
| 0.836 | 1 | < 0.1% |
| 0.852 | 1 | < 0.1% |
| 0.876 | 1 | < 0.1% |
| 0.898 | 1 | < 0.1% |
| 0.984 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 1.044 | 1 | < 0.1% |
| 1.08 | 3 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.976 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.790102 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2212373 |
|---|---|
| Coefficient of variation (CV) | 0.58606267 |
| Kurtosis | 1.9538619 |
| Mean | 3.790102 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2707753 |
| Sum | 37143 |
| Variance | 4.9338953 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 3 | 2368 | |
| 2 | 2352 | |
| 5 | 1206 | |
| 4 | 1166 | |
| 1 | 878 | 9.0% |
| 7 | 587 | 6.0% |
| 6 | 570 | 5.8% |
| 9 | 257 | 2.6% |
| 8 | 252 | 2.6% |
| 10 | 55 | 0.6% |
| Other values (4) | 109 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 878 | 9.0% |
| 2 | 2352 | |
| 3 | 2368 | |
| 4 | 1166 | |
| 5 | 1206 | |
| 6 | 570 | 5.8% |
| 7 | 587 | 6.0% |
| 8 | 252 | 2.6% |
| 9 | 257 | 2.6% |
| 10 | 55 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 27 | 0.3% |
| 13 | 26 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 33 | 0.3% |
| 10 | 55 | 0.6% |
| 9 | 257 | 2.6% |
| 8 | 252 | 2.6% |
| 7 | 587 | |
| 6 | 570 | |
| 5 | 1206 |
Discount
Real number (ℝ)
ZEROS
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15679796 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 4691 |
| Zeros (%) | 47.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20682026 |
|---|---|
| Coefficient of variation (CV) | 1.319024 |
| Kurtosis | 2.3871896 |
| Mean | 0.15679796 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6795044 |
| Sum | 1536.62 |
| Variance | 0.042774622 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 4691 | |
| 0.2 | 3590 | |
| 0.7 | 412 | 4.2% |
| 0.8 | 297 | 3.0% |
| 0.3 | 226 | 2.3% |
| 0.4 | 203 | 2.1% |
| 0.6 | 134 | 1.4% |
| 0.1 | 93 | 0.9% |
| 0.5 | 66 | 0.7% |
| 0.15 | 51 | 0.5% |
| Other values (2) | 37 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4691 | |
| 0.1 | 93 | 0.9% |
| 0.15 | 51 | 0.5% |
| 0.2 | 3590 | |
| 0.3 | 226 | 2.3% |
| 0.32 | 26 | 0.3% |
| 0.4 | 203 | 2.1% |
| 0.45 | 11 | 0.1% |
| 0.5 | 66 | 0.7% |
| 0.6 | 134 | 1.4% |
| Value | Count | Frequency (%) |
| 0.8 | 297 | 3.0% |
| 0.7 | 412 | 4.2% |
| 0.6 | 134 | 1.4% |
| 0.5 | 66 | 0.7% |
| 0.45 | 11 | 0.1% |
| 0.4 | 203 | 2.1% |
| 0.32 | 26 | 0.3% |
| 0.3 | 226 | 2.3% |
| 0.2 | 3590 | |
| 0.15 | 51 | 0.5% |
Profit
Real number (ℝ)
| Distinct | 7184 |
|---|---|
| Distinct (%) | 73.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.467205 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 62 |
| Zeros (%) | 0.6% |
| Negative | 1847 |
| Negative (%) | 18.8% |
| Memory size | 76.7 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -53.78352 |
| Q1 | 1.7045 |
| median | 8.5556 |
| Q3 | 29.3412 |
| 95-th percentile | 169.24846 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 27.6367 |
Descriptive statistics
| Standard deviation | 236.01112 |
|---|---|
| Coefficient of variation (CV) | 8.290632 |
| Kurtosis | 393.12161 |
| Mean | 28.467205 |
| Median Absolute Deviation (MAD) | 10.7726 |
| Skewness | 7.5306034 |
| Sum | 278978.61 |
| Variance | 55701.249 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 62 | 0.6% |
| 6.2208 | 42 | 0.4% |
| 9.3312 | 38 | 0.4% |
| 5.4432 | 32 | 0.3% |
| 3.6288 | 31 | 0.3% |
| 15.552 | 26 | 0.3% |
| 12.4416 | 20 | 0.2% |
| 7.2576 | 19 | 0.2% |
| 3.1104 | 16 | 0.2% |
| 10.8864 | 10 | 0.1% |
| Other values (7174) | 9504 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2639.9912 | 1 | |
| -2287.782 | 1 | |
| -1862.3124 | 1 | |
| -1850.9464 | 1 | |
| -1811.0784 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2799.984 | 1 | |
| 2591.9568 | 1 | |
| 2504.2216 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | CA-2017-152156 | 8/11/2017 | 11/11/2017 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420.0 | South | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.9600 | 2 | 0.00 | 41.9136 |
| 1 | 2 | CA-2017-152156 | 8/11/2017 | 11/11/2017 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420.0 | South | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.9400 | 3 | 0.00 | 219.5820 |
| 2 | 3 | CA-2017-138688 | 12/6/2017 | 6/16/2017 | Second Class | DV-13045 | Darrin Van Huff | Corporate | United States | Los Angeles | California | 90036.0 | West | OFF-LA-10000240 | Office Supplies | Labels | Self-Adhesive Address Labels for Typewriters by Universal | 14.6200 | 2 | 0.00 | 6.8714 |
| 3 | 4 | US-2016-108966 | 11/10/2016 | 10/18/2016 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311.0 | South | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.5775 | 5 | 0.45 | -383.0310 |
| 4 | 5 | US-2016-108966 | 11/10/2016 | 10/18/2016 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311.0 | South | OFF-ST-10000760 | Office Supplies | Storage | Eldon Fold 'N Roll Cart System | 22.3680 | 2 | 0.20 | 2.5164 |
| 5 | 6 | CA-2015-115812 | 9/6/2015 | 6/14/2015 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032.0 | West | FUR-FU-10001487 | Furniture | Furnishings | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 48.8600 | 7 | 0.00 | 14.1694 |
| 6 | 7 | CA-2015-115812 | 9/6/2015 | 6/14/2015 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032.0 | West | OFF-AR-10002833 | Office Supplies | Art | Newell 322 | 7.2800 | 4 | 0.00 | 1.9656 |
| 7 | 8 | CA-2015-115812 | 9/6/2015 | 6/14/2015 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032.0 | West | TEC-PH-10002275 | Technology | Phones | Mitel 5320 IP Phone VoIP phone | 907.1520 | 6 | 0.20 | 90.7152 |
| 8 | 9 | CA-2015-115812 | 9/6/2015 | 6/14/2015 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032.0 | West | OFF-BI-10003910 | Office Supplies | Binders | DXL Angle-View Binders with Locking Rings by Samsill | 18.5040 | 3 | 0.20 | 5.7825 |
| 9 | 10 | CA-2015-115812 | 9/6/2015 | 6/14/2015 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032.0 | West | OFF-AP-10002892 | Office Supplies | Appliances | Belkin F5C206VTEL 6 Outlet Surge | 114.9000 | 5 | 0.00 | 34.4700 |
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9790 | 9791 | CA-2018-144491 | 3/27/2018 | 1/4/2018 | Standard Class | CJ-12010 | Caroline Jumper | Consumer | United States | Houston | Texas | 77070.0 | Central | FUR-CH-10001714 | Furniture | Chairs | Global Leather & Oak Executive Chair, Burgundy | 211.246 | 2 | 0.3 | -66.3916 |
| 9791 | 9792 | CA-2015-127166 | 5/21/2015 | 5/23/2015 | Second Class | KH-16360 | Katherine Hughes | Consumer | United States | Houston | Texas | 77070.0 | Central | OFF-EN-10003134 | Office Supplies | Envelopes | Staple envelope | 56.064 | 6 | 0.2 | 21.0240 |
| 9792 | 9793 | CA-2015-127166 | 5/21/2015 | 5/23/2015 | Second Class | KH-16360 | Katherine Hughes | Consumer | United States | Houston | Texas | 77070.0 | Central | FUR-CH-10003396 | Furniture | Chairs | Global Deluxe Steno Chair | 107.772 | 2 | 0.3 | -29.2524 |
| 9793 | 9794 | CA-2015-127166 | 5/21/2015 | 5/23/2015 | Second Class | KH-16360 | Katherine Hughes | Consumer | United States | Houston | Texas | 77070.0 | Central | OFF-PA-10001560 | Office Supplies | Paper | Adams Telephone Message Books, 5 1/4” x 11” | 4.832 | 1 | 0.2 | 1.6308 |
| 9794 | 9795 | CA-2015-127166 | 5/21/2015 | 5/23/2015 | Second Class | KH-16360 | Katherine Hughes | Consumer | United States | Houston | Texas | 77070.0 | Central | OFF-BI-10000977 | Office Supplies | Binders | Ibico Plastic Spiral Binding Combs | 18.240 | 3 | 0.8 | -31.0080 |
| 9795 | 9796 | CA-2017-125920 | 5/21/2017 | 5/28/2017 | Standard Class | SH-19975 | Sally Hughsby | Corporate | United States | Chicago | Illinois | 60610.0 | Central | OFF-BI-10003429 | Office Supplies | Binders | Cardinal HOLDit! Binder Insert Strips,Extra Strips | 3.798 | 3 | 0.8 | -5.8869 |
| 9796 | 9797 | CA-2016-128608 | 12/1/2016 | 1/17/2016 | Standard Class | CS-12490 | Cindy Schnelling | Corporate | United States | Toledo | Ohio | 43615.0 | East | OFF-AR-10001374 | Office Supplies | Art | BIC Brite Liner Highlighters, Chisel Tip | 10.368 | 2 | 0.2 | 1.5552 |
| 9797 | 9798 | CA-2016-128608 | 12/1/2016 | 1/17/2016 | Standard Class | CS-12490 | Cindy Schnelling | Corporate | United States | Toledo | Ohio | 43615.0 | East | TEC-PH-10004977 | Technology | Phones | GE 30524EE4 | 235.188 | 2 | 0.4 | -43.1178 |
| 9798 | 9799 | CA-2016-128608 | 12/1/2016 | 1/17/2016 | Standard Class | CS-12490 | Cindy Schnelling | Corporate | United States | Toledo | Ohio | 43615.0 | East | TEC-PH-10000912 | Technology | Phones | Anker 24W Portable Micro USB Car Charger | 26.376 | 4 | 0.4 | 2.6376 |
| 9799 | 9800 | CA-2016-128608 | 12/1/2016 | 1/17/2016 | Standard Class | CS-12490 | Cindy Schnelling | Corporate | United States | Toledo | Ohio | 43615.0 | East | TEC-AC-10000487 | Technology | Accessories | SanDisk Cruzer 4 GB USB Flash Drive | 10.384 | 2 | 0.2 | 2.2066 |